Tabela GPPatientIdentification

Definicja tabeli GPPatientIdentification

Name

GPPatientIdentification

Code

GPPatientIdentification

Comment

Tabela identyfikatorów na potrzeby sprawozdawania deklaracji POZ.


Lista kolumn tabeli GPPatientIdentification

Name

Code

PersonID

PersonID

IdentificationTypeID

IdentificationTypeID

PatientIdentificationNo

PatientIdentificationNo

PatientNoTypeCode

PatientNoTypeCode

CareTakerPersonID

CareTakerPersonID


Kolumna PersonID tabeli GPPatientIdentification

Definicja kolumny PersonID tabeli GPPatientIdentification

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna IdentificationTypeID tabeli GPPatientIdentification

Definicja kolumny IdentificationTypeID tabeli GPPatientIdentification

Name

IdentificationTypeID

Code

IdentificationTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PatientIdentificationNo tabeli GPPatientIdentification

Definicja kolumny PatientIdentificationNo tabeli GPPatientIdentification

Name

PatientIdentificationNo

Code

PatientIdentificationNo

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Identyfikator pacjenta


Kolumna PatientNoTypeCode tabeli GPPatientIdentification

Definicja kolumny PatientNoTypeCode tabeli GPPatientIdentification

Name

PatientNoTypeCode

Code

PatientNoTypeCode

Data Type

VARCHAR2(2)

Mandatory

No

Comment

Kod identyfikatora pacjenta w przypadku identyfikatora
opiekuna prawnego.


Kolumna CareTakerPersonID tabeli GPPatientIdentification

Definicja kolumny CareTakerPersonID tabeli GPPatientIdentification

Name

CareTakerPersonID

Code

CareTakerPersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator bazodanowy rodzica/opiekuna prawnego


Lista kluczy tabeli GPPatientIdentification

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli GPPatientIdentification

Definicja klucza Identifier_1 tabeli GPPatientIdentification

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment